package com.shudai.largescreen.pojo.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
import lombok.*;

@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Builder
@HeadStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER,verticalAlignment = VerticalAlignmentEnum.CENTER)//标题样式,垂直水平居中
@HeadFontStyle(fontName = "微软雅黑",fontHeightInPoints = 11,bold = BooleanEnum.FALSE)//表头字体样式
@HeadRowHeight(value = 50)//表头行高
@ContentFontStyle(fontName = "微软雅黑",fontHeightInPoints = 11)//内容字体样式
@ContentRowHeight(value = 30)//内容行高
@ContentStyle(horizontalAlignment = HorizontalAlignmentEnum.CENTER,verticalAlignment = VerticalAlignmentEnum.CENTER)//内容样式,垂直水平居中
public class ExcelVoList {

    @ExcelProperty(value = "服务商",index = 0)
    String serviceProvider;//服务商
    @ExcelProperty(value = "业务员",index = 1)
    // 11月目标
    String salesman;//业务员
    @ExcelProperty(value = "录入拜访",index = 2)
    String visit1;//录入拜访
    @ExcelProperty(value = "定制成交",index = 3)
    String custom1;//录入拜访
    @ExcelProperty(value = "标品袋",index = 4)
    String sample1;//录入拜访

    //第一周 目标
    @ExcelProperty(value = "录入拜访",index = 5)
    String visit2;//录入拜访
    @ExcelProperty(value = "定制成交",index = 6)
    String custom2;//录入拜访
    @ExcelProperty(value = "标品袋",index = 7)
    String sample2;//录入拜访

    // 达成
    @ExcelProperty(value = "录入拜访",index = 8)
    String visit3;//录入拜访
    @ExcelProperty(value = "定制成交",index = 9)
    String custom3;//录入拜访
    @ExcelProperty(value = "标品袋",index = 10)
    String sample3;//录入拜访

    //差异
    @ExcelProperty(value = "录入拜访",index = 11)
    String visit4;//录入拜访
    @ExcelProperty(value = "定制成交",index = 12)
    String custom4;//录入拜访
    @ExcelProperty(value = "标品袋",index = 13)
    String sample4;//录入拜访

    //第二周 目标
    @ExcelProperty(value = "录入拜访",index = 14)
    String visit5;//录入拜访
    @ExcelProperty(value = "定制成交",index = 15)
    String custom5;//录入拜访
    @ExcelProperty(value = "标品袋",index = 16)
    String sample5;//录入拜访

    // 达成
    @ExcelProperty(value = "录入拜访",index = 17)
    String visit6;//录入拜访
    @ExcelProperty(value = "定制成交",index = 18)
    String custom6;//录入拜访
    @ExcelProperty(value = "标品袋",index = 19)
    String sample6;//录入拜访

    //差异
    @ExcelProperty(value = "录入拜访",index = 20)
    String visit7;//录入拜访
    @ExcelProperty(value = "定制成交",index = 21)
    String custom7;//录入拜访
    @ExcelProperty(value = "标品袋",index = 22)
    String sample7;//录入拜访


    //第三周 目标
    @ExcelProperty(value = "录入拜访",index = 23)
    String visit8;//录入拜访
    @ExcelProperty(value = "定制成交",index = 24)
    String custom8;//录入拜访
    @ExcelProperty(value = "标品袋",index = 25)
    String sample8;//录入拜访

    // 达成
    @ExcelProperty(value = "录入拜访",index = 26)
    String visit9;//录入拜访
    @ExcelProperty(value = "定制成交",index = 27)
    String custom9;//录入拜访
    @ExcelProperty(value = "标品袋",index = 28)
    String sample9;//录入拜访

    //差异
    @ExcelProperty(value = "录入拜访",index = 29)
    String visit10;//录入拜访
    @ExcelProperty(value = "定制成交",index = 30)
    String custom10;//录入拜访
    @ExcelProperty(value = "标品袋",index = 31)
    String sample10;//录入拜访

    //第四周 目标
    @ExcelProperty(value = "录入拜访",index = 32)
    String visit11;//录入拜访
    @ExcelProperty(value = "定制成交",index = 33)
    String custom11;//录入拜访
    @ExcelProperty(value = "标品袋",index = 34)
    String sample11;//录入拜访

    // 达成
    @ExcelProperty(value = "录入拜访",index = 35)
    String visit12;//录入拜访
    @ExcelProperty(value = "定制成交",index = 36)
    String custom12;//录入拜访
    @ExcelProperty(value = "标品袋",index = 37)
    String sample12;//录入拜访

    //差异
    @ExcelProperty(value = "录入拜访",index = 38)
    String visit13;//录入拜访
    @ExcelProperty(value = "定制成交",index = 39)
    String custom13;//录入拜访
    @ExcelProperty(value = "标品袋",index = 40)
    String sample13;//录入拜访

    //第一周 达成
    @ExcelProperty(value = "录入拜访",index = 41)
    String visit14;//录入拜访
    @ExcelProperty(value = "定制成交",index = 42)
    String custom14;//录入拜访
    @ExcelProperty(value = "标品袋",index = 43)
    String sample14;//录入拜访

    //  差异
    @ExcelProperty(value = "录入拜访",index = 44)
    String visit15;//录入拜访
    @ExcelProperty(value = "定制成交",index = 45)
    String custom15;//录入拜访
    @ExcelProperty(value = "标品袋",index = 46)
    String sample15;//录入拜访

//    //差异
//    @ExcelProperty(value = "录入拜访",index = 47)
//    String visit16;//录入拜访
//    @ExcelProperty(value = "定制成交",index = 48)
//    String custom16;//录入拜访
//    @ExcelProperty(value = "标品袋",index = 49)
//    String sample16;//录入拜访

}
